
--additional fields for item_unit (UOM)
alter table item_unit add cBarcode VARCHAR(25) ,nPrice NUMERIC(18,2), nCost NUMERIC (18, 2),
		cType varchar (25), cRefID VARCHAR (25), cRefDesc VARCHAR (100)
GO

ALTER TABLE [dbo].[item_unit] ADD  CONSTRAINT [DF_item_unit_nPrice]  DEFAULT (0) FOR [nPrice]
GO

ALTER TABLE [dbo].[item_unit] ADD  CONSTRAINT [DF_item_unit_nCost]  DEFAULT (0) FOR [nCost]
GO

